๐Ÿ“– 9์žฅ ๋‘๋ฒˆ์งธ ์–‘ํŒŒ ๊ป์งˆ์„ ๋ฒ—๊ธฐ๊ธฐ ์œ„ํ•œ ์ค‘๊ฐ„ ์ ๊ฒ€

@Seongukbaek Posted February 16, 2022 ยท Updated February 16, 2022 ยท 32 min read

[์ž๋ฐ” ์›น ํ”„๋กœ๊ทธ๋ž˜๋ฐ Next Step - ๋ฐ•์žฌ์„ฑ]์„ ์ฝ๊ณ  ์ธ์šฉํ•˜๊ณ  ์ •๋ฆฌํ•˜๋Š” POST์ž…๋‹ˆ๋‹ค.

์ง€๊ธˆ๊นŒ์ง€ ํ•™์Šตํ•œ ๋‚ด์šฉ๋“ค์— ๋Œ€ํ•œ ์ ๊ฒ€ํ•ด๋ณด๋Š” ์‹œ๊ฐ„์ด๋‹ค.

๐Ÿšฉ ์ž์ฒด ์ ๊ฒ€ ์š”๊ตฌ์‚ฌํ•ญ

๐Ÿ’ก 1. ๋กœ์ปฌ ๊ฐœ๋ฐœ ํ™˜๊ฒฝ์— ํ†ฐ์บฃ ์„œ๋ฒ„๋ฅผ ์‹œ์ž‘ํ•˜๋ฉด ์„œ๋ธ”๋ฆฟ ์ปจํ…Œ์ด๋„ˆ์˜ ์ดˆ๊ธฐํ™” ๊ณผ์ •์ด ์ง„ํ–‰๋œ๋‹ค. ์ดˆ๊ธฐํ™”๋˜๋Š” ๊ณผ์ •์— ๋Œ€ํ•ด ์„ค๋ช…ํ•˜๋ผ. (ํ”„๋กœ์ ํŠธ์˜ ์ดˆ๊ธฐํ™” ๊ณผ์ •)

  • ์„œ๋ธ”๋ฆฟ ์ปจํ…Œ์ด๋„ˆ๋Š” ์›น ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์˜ ์ƒํƒœ๋ฅผ ๊ด€๋ฆฌํ•˜๋Š” ServletContext ๋ฅผ ์ƒ์„ฑํ•œ๋‹ค.
  • ServletContext ๊ฐ€ ์ดˆ๊ธฐํ™”๋˜๋ฉด, ์ดˆ๊ธฐํ™” ์ด๋ฒคํŠธ๊ฐ€ ๋ฐœ์ƒ๋œ๋‹ค.
  • ๋“ฑ๋ก๋œ ServletContextListener ์˜ ์ฝœ๋ฐฑ ๋ฉ”์†Œ๋“œ๊ฐ€ ํ˜ธ์ถœ๋œ๋‹ค.

    • ์—ฌ๊ธฐ์„œ๋Š” public class ContextLoaderListener implements ServletContextListener ๋กœ ContextLoaderListener ๊ฐ€ ServletContextListener ๋ฅผ ๊ตฌํ˜„ํ•˜๊ณ  ์žˆ์œผ๋ฏ€๋กœ, ํ•ด๋‹น ๊ตฌํ˜„๋ถ€์˜ contextInitialized() ๊ฐ€ ํ˜ธ์ถœ๋œ๋‹ค.
ResourceDatabasePopulator populator = new ResourceDatabasePopulator(); populator.addScript(new ClassPathResource("jwp.sql")); DatabasePopulatorUtils.execute(populator, ConnectionManager.getDataSource());
  • contextInitialized() ๋ฉ”์†Œ๋“œ๋กœ, jwp.sql ํŒŒ์ผ์„ ์‹คํ–‰ํ•ด DB ํ…Œ์ด๋ธ”์„ ์ดˆ๊ธฐํ™”ํ•œ๋‹ค.
  • ์„œ๋ธ”๋ฆฟ ์ปจํ…Œ์ด๋„ˆ๋Š” ํด๋ผ์ด์–ธํŠธ์˜ ์š”์ฒญ์„ ๋ฐ›์„ DispatcherServlet ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•˜๋Š”๋ฐ, loadOnStartup ์†์„ฑ์— ๋”ฐ๋ผ ์ƒ์„ฑ ์‹œ์ ์ด ๊ฒฐ์ •๋œ๋‹ค.

    • ์—ฌ๊ธฐ์„œ๋Š” loadOnStartup ์„ ์„ค์ •ํ•ด์„œ, ์„œ๋ธ”๋ฆฟ ์ปจํ…Œ์ด๋„ˆ ์‹œ์ž‘ ์‹œ์ ์— ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•œ๋‹ค.
    • 6์žฅ์˜ ์„ค๋ช… ์ฐธ๊ณ 
  • DispatcherServlet ์˜ init() ๋ฉ”์†Œ๋“œ๋ฅผ ์‹คํ–‰ํ•˜์—ฌ RequestMapping ๊ฐ์ฒด๋ฅผ ์ƒ์„ฑํ•œ๋‹ค.

    • ์ƒ์„ฑํ•œ RequestMapping ์˜ initMapping() ๋ฉ”์†Œ๋“œ๋ฅผ ํ˜ธ์ถœํ•ด ์š”์ฒญ URL๊ณผ Controller ์ธ์Šคํ„ด์Šค๋ฅผ ๋งคํ•‘ํ•œ๋‹ค.

๐Ÿ’ก 2. ๋กœ์ปฌ ๊ฐœ๋ฐœ ํ™˜๊ฒฝ์— ํ†ฐ์บฃ ์„œ๋ฒ„๋ฅผ ์‹œ์ž‘ํ•œ ํ›„ http://localhost:8080 ์œผ๋กœ ์ ‘๊ทผํ•˜๋ฉด ์งˆ๋ฌธ ๋ชฉ๋ก์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. URL๋กœ ์ ‘๊ทผํ•ด์„œ ์งˆ๋ฌธ ๋ชฉ๋ก์ด ๋ณด์ด๊ธฐ๊นŒ์ง€์˜ ์†Œ์Šค์ฝ”๋“œ์˜ ํ˜ธ์ถœ ์ˆœ์„œ ๋ฐ ํ๋ฆ„์„ ์„ค๋ช…ํ•˜๋ผ.

  • ์š”์ฒญ์„ ์ฒ˜๋ฆฌํ•˜๊ธฐ ์ „, ๋จผ์ € web.filter ์˜ ResourceFilter ์™€ CharacterEncodingFilter ์˜ doFilter() ๋ฉ”์†Œ๋“œ๊ฐ€ ์‹คํ–‰๋œ๋‹ค. (์ด ๋‘˜์€ Filter ๋ฅผ ๊ตฌํ˜„)
  • ํ•„ํ„ฐ๋ฅผ ๊ฑฐ์นœ ํ›„, urlPatterns="/" ์ธ DispatcherServlet ์œผ๋กœ ์š”์ฒญ์ด ์ „๋‹ฌ๋˜์–ด service() ๋ฉ”์†Œ๋“œ๊ฐ€ ํ˜ธ์ถœ๋œ๋‹ค.

    • ์š”์ฒญ URL์— ๋Œ€์‘ํ•˜๋Š” Controller ๊ฐ์ฒด์ธ HomeController ๋ฅผ ๋ฐ˜ํ™˜ํ•œ๋‹ค.
    • ์ฆ‰, HomeController ์—๊ฒŒ ์ž‘์—…์„ ์œ„์ž„ํ•˜์—ฌ HomeController ์˜ execute() ๋ฉ”์†Œ๋“œ๊ฐ€ ์‹คํ–‰๋œ๋‹ค.
    • ํ•ด๋‹น ๋ฉ”์†Œ๋“œ๋Š” return jspView("home.jsp").addObject("questions", questionDao.findAll()); ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ณ , DispatcherServlet ๋Š” ์ด๋ฅผ ๋ฐ›์•„ view.render(mav.getModel(), req, resp); ํ•œ๋‹ค. JspView ์˜ render() ๋Š” ์ „๋‹ฌ๋œ ๋ชจ๋ธ ๋ฐ์ดํ„ฐ๋ฅผ home.jsp ์— ์ „๋‹ฌํ•ด HTML์„ ์ƒ์„ฑํ•˜๊ณ  ์‘๋‹ตํ•œ๋‹ค.

๐Ÿ’ก 3. ์งˆ๋ฌธ ๋ชฉ๋ก์€ ์ •์ƒ ๋™์ž‘ํ•˜์ง€๋งŒ ์งˆ๋ฌธํ•˜๊ธฐ ๊ธฐ๋Šฅ์€ ๋™์ž‘ํ•˜์ง€ ์•Š๋Š”๋‹ค. ์ด๋ฅผ ๊ตฌํ˜„ํ•œ๋‹ค. ์งˆ๋ฌธ ์ถ”๊ฐ€ ๋กœ์ง์€ QuetionDao ํด๋ž˜์Šค์˜ insert() ๋ฉ”์†Œ๋“œ๋ฅผ ํ™œ์šฉํ•œ๋‹ค. ์งˆ๋ฌธํ•˜๊ธฐ ์„ฑ๊ณต ํ›„ ์งˆ๋ฌธ ๋ชฉ๋ก ํŽ˜์ด์ง€("/")๋กœ ์ด๋™ํ•ด์•ผ ํ•œ๋‹ค.

  • ๋จผ์ €, ์งˆ๋ฌธํ•˜๊ธฐ ๋ฒ„ํŠผ์˜ href ๋ฅผ ๋ณด๋ฉด, /qna/form ์œผ๋กœ ์ด๋™ํ•˜๋„๋ก ํ•œ๋‹ค.

    • ๋”ฐ๋ผ์„œ, /qna/form ์š”์ฒญ์„ ์ฒ˜๋ฆฌํ•  ์ปจํŠธ๋กค๋Ÿฌ๋ฅผ ์ƒ์„ฑํ•˜๊ณ , ์ด๋ฅผ RequestMapping ์— ๋“ฑ๋กํ•œ๋‹ค.
    • ์ƒ์„ฑํ•œ ์ปจํŠธ๋กค๋Ÿฌ๋Š” ์ง€๊ธˆ๊นŒ์ง€์™€ ๋™์ผํ•˜๊ฒŒ AbstractController ๋ฅผ ์ƒ์†ํ•˜๊ณ , execute() ๋ฅผ ๊ตฌํ˜„ํ•œ๋‹ค.
    • ์ด ์ปจํŠธ๋กค๋Ÿฌ์—์„œ๋Š” /qna/form.jsp ๋ฅผ ๋ฐ˜ํ™˜ํ•œ๋‹ค.
  • form.jsp ์—์„œ ๊ธ€์“ด์ด, ์ œ๋ชฉ, ๋‚ด์šฉ์„ ์ž…๋ ฅํ•œ ํ›„, /qna/create ๋กœ POST ์š”์ฒญ์„ ๋ณด๋‚ด๋„๋ก ํ•œ๋‹ค.

    • ์ด๋ฅผ ์ฒ˜๋ฆฌํ•  ์ปจํŠธ๋กค๋Ÿฌ๋ฅผ ์ƒ์„ฑํ•˜๊ณ , ๋งคํ•‘ํ•œ๋‹ค.
    • ํ•ด๋‹น ์ปจํŠธ๋กค๋Ÿฌ์—์„œ ์‚ฌ์šฉ์ž ์ž…๋ ฅ ๊ฐ’๋“ค(writer , title , contents)์„ ์‚ฌ์šฉํ•˜์—ฌ Question ๊ฐ์ฒด๋ฅผ ์ƒ์„ฑํ•œ๋‹ค.
    • ๊ทธ๋ฆฌ๊ณ  ์ƒ์„ฑํ•œ ์งˆ๋ฌธ ๊ฐ์ฒด๋ฅผ QuestionDao ์˜ insert() ๋ฉ”์†Œ๋“œ๋ฅผ ํ†ตํ•ด DB์— ์ €์žฅํ•œ๋‹ค.
    • QuestionDao ์˜ insert() ๋ฉ”์†Œ๋“œ๋Š” DB์— ์ธ์ž๋กœ ๋ฐ›์€ ์งˆ๋ฌธ ๊ฐ์ฒด๋ฅผ ์‚ฝ์ž…ํ•˜๋Š” ์—ญํ• ์„ ์ˆ˜ํ–‰ํ•œ๋‹ค.
public Question insert(Question question) { JdbcTemplate jdbcTemplate = new JdbcTemplate(); String sql = "INSERT INTO QUESTIONS (writer, title, contents, createdDate) VALUES (?, ?, ?, ?)"; PreparedStatementCreator psc = new PreparedStatementCreator() { @Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, question.getWriter()); pstmt.setString(2, question.getTitle()); pstmt.setString(3, question.getContents()); pstmt.setTimestamp(4, new Timestamp(question.getTimeFromCreateDate())); return pstmt; } }; KeyHolder keyHolder = new KeyHolder(); jdbcTemplate.update(psc, keyHolder); return findById(keyHolder.getId()); }

๐Ÿ’ก 4. ๋กœ๊ทธ์ธํ•˜์ง€ ์•Š์€ ์‚ฌ์šฉ์ž๋„ ์งˆ๋ฌธํ•˜๊ธฐ๊ฐ€ ๊ฐ€๋Šฅํ•˜๋‹ค. ์ด๋ฅผ ๋กœ๊ทธ์ธํ•œ ์‚ฌ์šฉ์ž๋งŒ ์งˆ๋ฌธ์ด ๊ฐ€๋Šฅํ•˜๋„๋ก ์ˆ˜์ •ํ•œ๋‹ค. ์ด๋•Œ ๊ธ€์“ด์ด๋ฅผ ์ž…๋ ฅํ•˜์ง€ ์•Š๊ณ  ๋กœ๊ทธ์ธํ•œ ์‚ฌ์šฉ์ž ์ •๋ณด๋ฅผ ๊ฐ€์ ธ์™€ ๊ธ€์“ด์ด ์ด๋ฆ„์œผ๋กœ ์‚ฌ์šฉํ•˜๋„๋ก ๊ตฌํ˜„ํ•œ๋‹ค.

  • ์งˆ๋ฌธํ•˜๊ธฐ ๋ฒ„ํŠผ ํด๋ฆญ ์‹œ, ๋จผ์ € session์œผ๋กœ๋ถ€ํ„ฐ ์‚ฌ์šฉ์ž ์ •๋ณด๋ฅผ ๊ฐ€์ ธ์™€ ๋กœ๊ทธ์ธ๋œ ์‚ฌ์šฉ์ž์ธ์ง€ ํ™•์ธํ•˜๊ณ , ๊ทธ๋ ‡์ง€ ์•Š์€ ๊ฒฝ์šฐ์—๋Š” /users/loginForm ์œผ๋กœ ๋ณด๋‚ธ๋‹ค.
  • CreateQuestionController ์—์„œ๋„ ๋กœ๊ทธ์ธ ์œ ๋ฌด๋ฅผ ํ™•์ธํ•œ ํ›„ ์‚ฌ์šฉ์ž๊ฐ€ ์ž…๋ ฅํ•œ ๊ธ€์“ด์ด ์ •๋ณด๊ฐ€ ์•„๋‹Œ session์œผ๋กœ๋ถ€ํ„ฐ ๊ฐ€์ ธ์˜จ userId ๋ฅผ Question ๊ฐ์ฒด์— ๋‹ด์•„ ์ €์žฅํ•œ๋‹ค.

๐Ÿ’ก 5. ์งˆ๋ฌธ ๋ชฉ๋ก์—์„œ ์ œ๋ชฉ์„ ํด๋ฆญํ•˜๋ฉด ์ƒ์„ธ๋ณด๊ธฐ ํ™”๋ฉด์œผ๋กœ ์ด๋™ํ•œ๋‹ค. ํ•ด๋‹น ํ™”๋ฉด์—์„œ ๋‹ต๋ณ€ ๋ชฉ๋ก์ด ์ •์ ์ธ HTML๋กœ ๊ตฌํ˜„๋˜์–ด ์žˆ๋Š”๋ฐ, ์ด๋ฅผ DB์— ์ €์ •๋˜์–ด ์žˆ๋Š” ๋‹ต๋ณ€์„ ์ถœ๋ ฅํ•˜๋„๋ก ๊ตฌํ˜„ํ•œ๋‹ค. ์Šคํด๋ฆฝํ‹€๋ฆฟ์„ ์‚ฌ์šฉํ•˜์ง€ ์•Š๊ณ  JSTL๊ณผ EL๋งŒ์œผ๋กœ ๊ตฌํ˜„ํ•œ๋‹ค.

  • ์ด๊ฑด ๋ญ์ง€

๐Ÿ’ก 6. ์ž๋ฐ” ๊ธฐ๋ฐ˜ ์›น ํ”„๋กœ๊ทธ๋ž˜๋ฐ์„ ํ•  ๊ฒฝ์šฐ ํ•œ๊ธ€์ด ๊นจ์ง„๋‹ค. ์ด๋ฅผ ServletFilter ๋ฅผ ํ™œ์šฉํ•ด ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค. core.web.filter.CharacterEncodingFilter ์— annotation ์„ค์ •์„ ํ†ตํ•ด ํ•œ๊ธ€ ๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•œ๋‹ค.

  • @WebFilter(value= {"/*"}, initParams=@WebInitParam(name="encoding", value="utf-8")) annotation์„ ์„ค์ •ํ•œ๋‹ค.
  • request.setCharacterEncoding(DEFAULT_ENCODING); & response.setCharacterEncoding(DEFAULT_ENCODING); ์œผ๋กœ request์™€ response์— ๋Œ€ํ•œ ํ•œ๊ธ€ ์ธ์ฝ”๋”ฉ ์ฒ˜๋ฆฌ๋ฅผ ์ˆ˜ํ–‰ํ•œ๋‹ค. (DEFAULT_ENCODING= "UTF-8";)
  • FilterChain ๊ฐ์ฒด๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ chain.doFilter(request, response); ๋ฉ”์†Œ๋“œ๋ฅผ ํ˜ธ์ถœํ•œ๋‹ค. ์ด๋Š” ํ•„ํ„ฐ์ž‘์—…(ํ•œ๊ธ€์ฒ˜๋ฆฌ)์˜ ๋‚ด์šฉ์ด ์„œ๋ฒ„์ƒ์˜ ๋‹ค์Œ ์ปดํฌ๋„ŒํŠธ์—๊ฒŒ ๊ณ„์† ์ ์šฉ๋˜๋„๋ก ํ•˜๊ธฐ ์œ„ํ•ด ํ•„์š”ํ•˜๋‹ค.

๐Ÿ’ก 7. next.web.qna ํŒจํ‚ค์ง€์˜ ShowController ๋Š” ๋ฉ€ํ‹ฐ์Šค๋ ˆ๋“œ ์ƒํ™ฉ์—์„œ ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•  ๊ฐ€๋Šฅ์„ฑ์ด ์žˆ๋‹ค. ์ด๋ฅผ ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•˜์ง€ ์•Š๋„๋ก ์ˆ˜์ •ํ•˜๊ณ , ๋ฌธ์ œ๊ฐ€ ๋˜๋Š” ์ด์œ ๋ฅผ ์„ค๋ช…ํ•˜๋ผ.

  • ํด๋ž˜์Šค์˜ ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•˜๋Š” ๊ฒƒ๊ณผ ์ธ์Šคํ„ด์Šค๋ฅผ ๋” ์ด์ƒ ์‚ฌ์šฉํ•˜์ง€ ์•Š๋Š” ๊ฒฝ์šฐ Garbage Collection์„ ํ†ตํ•ด ๋ฉ”๋ชจ๋ฆฌ์—์„œ ํ•ด์ œํ•˜๋Š” ๊ณผ์ • ๋ชจ๋‘ ๋น„์šฉ์ด ๋ฐœ์ƒํ•œ๋‹ค.

    • ๋”ฐ๋ผ์„œ, ์ธ์Šคํ„ด์Šค๋ฅผ ๋งค๋ฒˆ ์ƒ์„ฑํ•  ํ•„์š”๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ, ์ƒ์„ฑ๋œ ์ธ์Šคํ„ด์Šค๋ฅผ ์žฌ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ์ด ์„ฑ๋Šฅ ์ธก๋ฉด์—์„œ ๋” ์œ ๋ฆฌํ•  ์ˆ˜ ์žˆ๋‹ค.
    • ์ด๋Š” ์ธ์Šคํ„ด์Šค๊ฐ€ ์ƒํƒœ ๊ฐ’์„ ์œ ์ง€ํ•ด์•ผ ํ•˜๋Š”์ง€ ์—ฌ๋ถ€์— ๋”ฐ๋ผ ๊ตฌ๋ถ„๋œ๋‹ค.
    • ์˜ˆ๋กœ, model ์˜ User , Question , Answer ์˜ ๊ฒฝ์šฐ ํด๋ผ์ด์–ธํŠธ๋งˆ๋‹ค ์„œ๋กœ ๋‹ค๋ฅธ ์ƒํƒœ ๊ฐ’์„ ๊ฐ€์ง€๊ธฐ์—, ๋งค ์š”์ฒญ๋งˆ๋‹ค ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•˜์—ฌ ์ฒ˜๋ฆฌํ•ด์•ผ ํ•œ๋‹ค.
    • ํ•˜์ง€๋งŒ, JdbcTemplate , ๋ชจ๋“  Dao , Controller ๋Š” ๋งค ์š”์ฒญ๋งˆ๋‹ค ์„œ๋กœ ๋‹ค๋ฅธ ์ƒํƒœ ๊ฐ’์„ ๊ฐ€์ง€์ง€ ์•Š์•„ ํ•˜๋‚˜์˜ ์ธ์Šคํ„ด์Šค๋ฅผ ์žฌ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค.
  • ์„œ๋ธ”๋ฆฟ์€ ์„œ๋ธ”๋ฆฟ ์ปจํ…Œ์ด๋„ˆ ์‹œ์ž‘ ์‹œ ์ธ์Šคํ„ด์Šค ํ•˜๋‚˜๋ฅผ ์ƒ์„ฑํ•ด ์žฌ์‚ฌ์šฉํ•œ๋‹ค. RequestMapping ๊ณผ ๊ฐ ์ปจํŠธ๋กค๋Ÿฌ์˜ ์ธ์Šคํ„ด์Šค ๋˜ํ•œ ๋ชจ๋‘ ํ•˜๋‚˜์ด๋‹ค.

    • ํ•˜์ง€๋งŒ ์„œ๋ธ”๋ฆฟ ์ปจํ…Œ์ด๋„ˆ๋Š” ๋ฉ€ํ‹ฐ์Šค๋ ˆ๋“œ ํ™˜๊ฒฝ์—์„œ ๋™์ž‘ํ•œ๋‹ค. ์—ฌ๋Ÿฌ ๋ช…์˜ ์‚ฌ์šฉ์ž๊ฐ€ ์ธ์Šคํ„ด์Šค ํ•˜๋‚˜๋ฅผ ์žฌ์‚ฌ์šฉํ•œ๋‹ค๋Š” ์˜๋ฏธ์ด๋ฏ€๋กœ, ์ž˜๋ชป๋œ ๊ตฌํ˜„์œผ๋กœ ์ธํ•ด ๋ฒ„๊ทธ๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๋‹ค. (์—ฌ๋Ÿฌ ๋ช…์˜ ์‚ฌ์šฉ์ž๊ฐ€ ๋™์‹œ์— ๊ฐ™์€ ์ฝ”๋“œ๋ฅผ ์‹คํ–‰ํ•˜๋Š” ๊ฒฝ์šฐ ๋ฐœ์ƒ)

ShowController ๋Š” ์ธ์Šคํ„ด์Šค ํ•˜๋‚˜๋ฅผ ์—ฌ๋Ÿฌ ๊ฐœ์˜ ์Šค๋ ˆ๋“œ๊ฐ€ ๊ณต์œ ํ•œ๋‹ค. ๋จผ์ € ๋ฉ”๋ชจ๋ฆฌ์—์„œ ์–ด๋–ป๊ฒŒ ๋™์ž‘ํ•˜๋Š”์ง€๋ฅผ ์‚ดํŽด๋ณธ๋‹ค.

  • JVM์€ ์ฝ”๋“œ๋ฅผ ์‹คํ–‰ํ•˜๊ธฐ ์œ„ํ•ด ๋ฉ”๋ชจ๋ฆฌ๋ฅผ ์Šคํƒ๊ณผ ํž™ ์˜์—ญ์œผ๋กœ ๋‚˜๋ˆ ์„œ ๊ด€๋ฆฌํ•œ๋‹ค.

    • ์Šคํƒ ์˜์—ญ์€ ๊ฐ ๋ฉ”์†Œ๋“œ๊ฐ€ ์‹คํ–‰๋  ๋•Œ, ๋ฉ”์†Œ๋“œ์˜ ์ธ์ž, ์ง€์—ญ ๋ณ€์ˆ˜ ๋“ฑ์„ ๊ด€๋ฆฌํ•˜๋Š” ์˜์—ญ์œผ๋กœ, ๊ฐ ์Šค๋ ˆ๋“œ๋งˆ๋‹ค ๊ณ ์œ ํ•œ ์˜์—ญ์„ ๊ฐ€์ง„๋‹ค.
    • ํž™ ์˜์—ญ์€ ํด๋ž˜์Šค์˜ ์ธ์Šคํ„ด์Šค ์ƒํƒœ ๋ฐ์ดํ„ฐ๋ฅผ ๊ด€๋ฆฌํ•˜๋Š” ์˜์—ญ์œผ๋กœ, ์Šค๋ ˆ๋“œ๋ผ๋ฆฌ ๊ณต์œ ํ•  ์ˆ˜ ์žˆ๋‹ค.
  • JVM์€ ๊ฐ ๋ฉ”์†Œ๋“œ๋ณ„๋กœ ์Šคํƒ ํ”„๋ ˆ์ž„์„ ์ƒ์„ฑํ•œ๋‹ค.
  • ShowController ์˜ execute() ๋ฉ”์†Œ๋“œ ์‹คํ–‰ ์‹œ, ํ•ด๋‹น ๋ฉ”์†Œ๋“œ์— ๋Œ€ํ•œ ์Šคํƒ ํ”„๋ ˆ์ž„์˜ ์ง€์—ญ ๋ณ€์ˆ˜ ์˜์—ญ์˜ ์ฒซ๋ฒˆ์งธ ์œ„์น˜์— ์ž๊ธฐ ์ž์‹ (this)์— ๋Œ€ํ•œ ๋ฉ”๋ชจ๋ฆฌ ์œ„์น˜๋ฅผ ์ƒ์„ฑํ•œ๋‹ค.
  • ShowController ์˜ ์ธ์Šคํ„ด์Šค๋Š” ํž™์— ์ƒ์„ฑ๋˜๋ฉฐ, Question , List<Answer> ํ•„๋“œ๋ฅผ ๊ฐ€์ง€๋ฏ€๋กœ ํž™์— ์ƒ์„ฑ๋œ Question ๊ณผ List<Answer> ์ธ์Šคํ„ด์Šค๋ฅผ ๊ฐ€๋ฆฌํ‚ค๋Š” ๊ตฌ์กฐ๋กœ ์‹คํ–‰๋œ๋‹ค.

์œ„ ๊ตฌ์กฐ์—์„œ, 2๊ฐœ์˜ ์Šค๋ ˆ๋“œ๊ฐ€ execute() ๋ฉ”์†Œ๋“œ๋ฅผ ์‹คํ–‰ํ•˜๊ฒŒ ๋˜๋ฉด,

  • ์ฒซ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ๊ฐ€ ์ ‘๊ทผํ–ˆ์„ ๋•Œ๋Š” ๋ฌธ์ œ๊ฐ€ ๋˜์ง€ ์•Š๋Š”๋‹ค.
  • ํ•˜์ง€๋งŒ, ์ฒซ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ์˜ ์ž‘์—…์ด ์™„๋ฃŒ๋˜์ง€ ์•Š์€ ์‹œ์ ์—์„œ ๋‘ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ๊ฐ€ execute() ๋ฉ”์†Œ๋“œ๋ฅผ ์‹คํ–‰ํ•˜๊ฒŒ ๋˜๋ฉด, ๋ฉ”๋ชจ๋ฆฌ ๊ตฌ์กฐ๊ฐ€ ๋‹ค์Œ๊ณผ ๊ฐ™์ด ๋ณ€ํ•œ๋‹ค.
  • ShowController ๊ฐ€ ๊ฐ€๋ฆฌํ‚ค๋Š” ํ•„๋“œ๊ฐ€ 1๋ฒˆ์—์„œ 2๋ฒˆ์œผ๋กœ ๋ณ€๊ฒฝ๋˜์—ˆ๋‹ค.
  • ๋‘ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ๋Š” ์ •์ƒ์ ์œผ๋กœ ์งˆ๋ฌธ๊ณผ ๋‹ต๋ณ€์„ ์‘๋‹ต์œผ๋กœ ๋ฐ›์ง€๋งŒ, ์ฒซ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ๋Š” 1๋ฒˆ ๊ธ€์„ ๋ณด๊ธฐ ์œ„ํ•œ ์š”์ฒญ์„ ๋ณด๋ƒˆ์Œ์—๋„ ๋‘ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ๊ฐ€ ์‹คํ–‰ํ•œ execute() ๋กœ ์ธํ•ด ShowController ๊ฐ€ ๊ฐ€๋ฆฌํ‚ค๋Š” ํ•„๋“œ๊ฐ€ 2๋ฒˆ์œผ๋กœ ๋ณ€๊ฒฝ๋˜์–ด 2๋ฒˆ ์งˆ๋ฌธ๊ณผ ๋‹ต๋ณ€์„ ์‘๋‹ต์œผ๋กœ ๋ฐ›๊ฒŒ ๋œ๋‹ค.
  • ์ฒซ ๋ฒˆ์งธ ์Šค๋ ˆ๋“œ๊ฐ€ ์ƒˆ๋กœ๊ณ ์นจ์„ ํ•˜๊ฒŒ ๋˜๋ฉด ์ •์ƒ์ ์ธ ์‘๋‹ต์„ ๋ฐ›์„ ์ˆ˜ ์žˆ์–ด ๋ฒ„๊ทธ๊ฐ€ ๊ณ ์ณ์ง€๋Š” ๋“ฏ ํ•˜์ง€๋งŒ, ์ด๋Ÿฌํ•œ ๋ฒ„๊ทธ๊ฐ€ ๋‹ค๋ฅธ ์ค‘์š”ํ•œ ๊ธฐ๋Šฅ์—๋„ ์ ์šฉ๋œ๋‹ค๋ฉด, ํฐ ํ”ผํ•ด๋ฅผ ์ž…์„ ์ˆ˜ ์žˆ๋‹ค.

"๋ฉ€ํ‹ฐ์Šค๋ ˆ๋“œ์—์„œ ์›น ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๊ฐœ๋ฐœ ์‹œ ๊ตฌํ˜„ํ•˜๊ณ  ์žˆ๋Š” ์ฝ”๋“œ๊ฐ€ ์–ด๋–ป๊ฒŒ ๋™์ž‘ํ•˜๋Š”์ง€๋ฅผ ์ดํ•ดํ•˜๋Š” ๊ฒƒ์€ ๋งค์šฐ ์ค‘์š”ํ•˜๋‹ค."

์ด๋Ÿฌํ•œ ๋ฒ„๊ทธ๋Š” Question ๊ณผ List<Answer> ๋ฅผ ShowController ์˜ ํ•„๋“œ๊ฐ€ ์•„๋‹Œ execute() ๋ฉ”์†Œ๋“œ์˜ ์ง€์—ญ ๋ณ€์ˆ˜๋กœ ๊ตฌํ˜„ํ•จ์œผ๋กœ์จ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค.

public class ShowController extends AbstractController { private QuestionDao questionDao = new QuestionDao(); private AnswerDao answerDao = new AnswerDao(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { Long questionId = Long.parseLong(req.getParameter("questionId")); Question question = questionDao.findById(questionId); List<Answer> answers = answerDao.findAllByQuestionId(questionId); return jspView("/qna/show.jsp").addObject("question", question).addObject("answers", answers); } }
  • ์ด์™€ ๊ฐ™์ด ๊ตฌํ˜„ํ•˜๋ฉด, ShowController ๊ฐ€ Question ๊ณผ List<Answer> ์ธ์Šคํ„ด์Šค์— ๋Œ€ํ•œ ์ฐธ์กฐ๋ฅผ ๊ฐ€์ง€์ง€ ์•Š๊ณ  ShowController execute() ๋ฉ”์†Œ๋“œ์˜ ์Šคํƒ ํ”„๋ ˆ์ž„์˜ ์ง€์—ญ ๋ณ€์ˆ˜ ์˜์—ญ์—์„œ ํ•ด๋‹น ์ธ์Šคํ„ด์Šค์— ๋Œ€ํ•œ ์ฐธ์กฐ๋ฅผ ๊ฐ€์ง„๋‹ค.
  • 2๊ฐœ์˜ ์Šค๋ ˆ๋“œ๊ฐ€ ์ ‘๊ทผํ•˜๋”๋ผ๋„, ์„œ๋กœ ๊ฐ™์€ ShowController ์ธ์Šคํ„ด์Šค๋ฅผ ์ฐธ์กฐํ•˜์ง€๋งŒ ํž™ ๋ฉ”๋ชจ๋ฆฌ์— ์ƒ์„ฑ๋œ Question ๊ณผ List<Answer> ๋Š” ์„œ๋กœ ๊ณ ์œ ํ•œ ์ธ์Šคํ„ด์Šค๋ฅผ ์ฐธ์กฐํ•˜๊ฒŒ ๋œ๋‹ค.

QuestionDao ์™€ AnswerDao ๋Š” ๋ชจ๋‘ ์ƒํƒœ ๊ฐ’์„ ๊ฐ€์ง€์ง€ ์•Š๊ธฐ์— ๋ฉ€ํ‹ฐ์Šค๋ ˆ๋“œ ํ™˜๊ฒฝ์—์„œ๋„ ๋ฌธ์ œ๊ฐ€ ๋˜์ง€ ์•Š๋Š”๋‹ค.

๐Ÿ’ก 8. ์ƒ์„ธ๋ณด๊ธฐ ํ™”๋ฉด์—์„œ ๋‹ต๋ณ€ํ•˜๊ธฐ ๊ธฐ๋Šฅ์€ ์ •์ƒ์ ์œผ๋กœ ๋™์ž‘ํ•œ๋‹ค. ๋‹จ, ๋‹ต๋ณ€ ์ถ”๊ฐ€ ์‹œ ์ „์ฒด ๋‹ต๋ณ€์˜ ์ˆ˜๊ฐ€ ์ฆ๊ฐ€ํ•˜์ง€ ์•Š๋Š”๋‹ค. ๋‹ต๋ณ€์„ ์ถ”๊ฐ€ํ•˜๋Š” ์‹œ์ ์— ์งˆ๋ฌธ(QUESTION ํ…Œ์ด๋ธ”)์˜ ๋‹ต๋ณ€ ์ˆ˜(countOfAnswer)๋„ 1 ์ฆ๊ฐ€์‹œํ‚จ๋‹ค.

  • ๋‹ต๋ณ€์„ ์ถ”๊ฐ€ํ•˜๋Š” ์‹œ์ ์— ๋‹ต๋ณ€ ์ˆ˜๋ฅผ ์ฆ๊ฐ€์‹œ์ผœ์•ผ ํ•˜๋ฏ€๋กœ, AddAnswerController ์—์„œ answerDao.insert() ์ดํ›„ ๋กœ์ง์ด ์ถ”๊ฐ€๋˜์–ด์•ผ ํ•œ๋‹ค.
  • ๋จผ์ €, questionDao ์— questionId ๋ฅผ ์ธ์ž๋กœ ๋ฐ›์•„ ์งˆ๋ฌธ์— ๋Œ€ํ•œ ๋‹ต๋ณ€ ์ˆ˜๋ฅผ ์ฆ๊ฐ€์‹œํ‚ค๋Š” DB ๋กœ์ง์„ ๊ตฌํ˜„ํ•œ๋‹ค.
public void updateCountOfAnswer(long questionId) { JdbcTemplate jdbcTemplate = new JdbcTemplate(); String sql = "UPDATE QUESTIONS SET countOfAnswer=countOfAnswer+1 " + "WHERE questionId = ?"; jdbcTemplate.update(sql, questionId); }
  • ๊ตฌํ˜„ํ•œ ๋กœ์ง์„ AddAnswerController ์—์„œ ์‚ฌ์šฉํ•˜๋„๋ก ํ•œ๋‹ค.
public class AddAnswerController extends AbstractController { ... private QuestionDao questionDao = new QuestionDao(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { ... Answer savedAnswer = answerDao.insert(answer); questionDao.updateCountOfAnswer(savedAnswer.getQuestionId()); return jsonView().addObject("answer", savedAnswer); } }

๐Ÿ’ก 9. ํ•ด๋‹น ์„œ๋น„์Šค๋Š” ๋ชจ๋ฐ”์ผ์—์„œ๋„ ์„œ๋น„์Šคํ•  ๊ณ„ํš์ด๋ผ API๋ฅผ ์ถ”๊ฐ€ํ•ด์•ผ ํ•œ๋‹ค. /api/qna/list URL๋กœ ์ ‘๊ทผ ์‹œ ์งˆ๋ฌธ ๋ชฉ๋ก์„ JSON ๋ฐ์ดํ„ฐ๋กœ ์กฐํšŒํ•  ์ˆ˜ ์žˆ๋„๋ก ๊ตฌํ˜„ํ•œ๋‹ค.

  • ๋จผ์ €, ํ•ด๋‹น ์š”์ฒญ URL์„ ์ฒ˜๋ฆฌํ•  ์ปจํŠธ๋กค๋Ÿฌ๋ฅผ ์ƒ์„ฑํ•˜๊ณ , RequestMapping ์—์„œ URL๊ณผ ํ•จ๊ป˜ ๋งคํ•‘ํ•œ๋‹ค.
  • ์ƒ์„ฑํ•œ ์ปจํŠธ๋กค๋Ÿฌ๋Š” QuestionDao ์˜ findAll() ๊ฒฐ๊ณผ๋ฅผ jsonView() ๋กœ ๋ฐ˜ํ™˜ํ•œ๋‹ค.
public class ApiListQuestionController extends AbstractController { private QuestionDao questionDao = new QuestionDao(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { return jsonView().addObject("question", questionDao.findAll()); } }

๐Ÿ’ก 10. ์ƒ์„ธ๋ณด๊ธฐ ํ™”๋ฉด์˜ ๋‹ต๋ณ€ ๋ชฉ๋ก์—์„œ ๋‹ต๋ณ€์„ ์‚ญ์ œํ•ด์•ผ ํ•œ๋‹ค. ๋‹ต๋ณ€ ์‚ญ์ œ ๋˜ํ•œ ์ƒˆ๋กœ๊ณ ์นจ ์—†์ด ๊ตฌํ˜„์ด ๊ฐ€๋Šฅํ•˜๋„๋ก AJAX๋กœ ๊ตฌํ˜„ํ•œ๋‹ค.

  • show.jsp ์—์„œ ๋‹ต๋ณ€ ์‚ญ์ œ ๋ฒ„ํŠผ ํด๋ฆญ ์‹œ ์š”์ฒญ์„ ๋ณด๋‚ผ URL์„ ๋ช…์‹œํ•˜๊ณ , ์ด๋ฅผ ์ฒ˜๋ฆฌํ•  ์ปจํŠธ๋กค๋Ÿฌ๋ฅผ ์ƒ์„ฑํ•œ๋‹ค. (๋งคํ•‘๋„ ์ˆ˜ํ–‰)
  • webapp/js/scripts.js ์—์„œ ์‚ญ์ œ ๋ฒ„ํŠผ ํด๋ฆญ ์‹œ ๋ฐœ์ƒ์‹œํ‚ฌ ์ด๋ฒคํŠธ๋ฅผ ๋ช…์‹œํ•˜๊ณ , AJAX๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์„œ๋ฒ„์—๊ฒŒ ์š”์ฒญ์„ ๋ณด๋‚ธ๋‹ค.
$(".qna-comment").on("click", ".form-delete", deleteAnswer); function deleteAnswer(e) { e.preventDefault(); var deleteBtn = $(this); var queryString = deleteBtn.closest("form").serialize(); $.ajax({ type: 'post', url: "/api/qna/deleteAnswer", data: queryString, dataType: 'json', error: function (xhr, status) { alert("error"); }, success: function (json, status) { var result = json.result; if (result.status) { deleteBtn.closest('article').remove(); } } }); }
  • ์ปจํŠธ๋กค๋Ÿฌ์—์„œ๋Š” ์š”์ฒญ์œผ๋กœ๋ถ€ํ„ฐ answerId ๋ฅผ ๊บผ๋‚ด DB์—์„œ ํ•ด๋‹น ๋‹ต๋ณ€์„ ์‚ญ์ œํ•˜๊ณ , ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•œ๋‹ค.
  • ๋ฐ˜ํ™˜๋ฐ›์€ ๊ฒฐ๊ณผ์— ๋”ฐ๋ผ, error or success ๋ถ€๋ถ„์„ ์‹คํ–‰ํ•˜์—ฌ ๋‹ต๋ณ€์„ ์‚ญ์ œํ•œ๋‹ค.
public class DeleteAnswerController extends AbstractController { private AnswerDao answerDao = new AnswerDao(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { Long answerId = Long.parseLong(req.getParameter("answerId")); try { answerDao.delete(answerId); return jsonView().addObject("result", Result.ok()); } catch (DataAccessException e) { return jsonView().addObject("result", Result.fail(e.getMessage())); } } }

๋‹ต๋ณ€ ์‚ญ์ œ ์‹œ, countOfAnswers ๋ฅผ -1 ํ•ด์ฃผ๋Š” ๋กœ์ง์ด ํ•„์š”ํ•  ๊ฒƒ ๊ฐ™๋‹ค.

๐Ÿ’ก 11. ์งˆ๋ฌธ ์ˆ˜์ •์ด ๊ฐ€๋Šฅํ•ด์•ผ ํ•œ๋‹ค. ์ด๋Š” ๊ธ€์“ด์ด์™€ ๋กœ๊ทธ์ธ ์‚ฌ์šฉ์ž๊ฐ€ ๊ฐ™์€ ๊ฒฝ์šฐ์—๋งŒ ๊ฐ€๋Šฅํ•ด์•ผ ํ•œ๋‹ค.

  • ์งˆ๋ฌธ ์ˆ˜์ • ๋ฒ„ํŠผ ํด๋ฆญ ์‹œ, ์š”์ฒญ์„ ๋ณด๋‚ผ URL์„ ๋ช…์‹œํ•˜๊ณ , ์งˆ๋ฌธ ์ˆ˜์ • ์–‘์‹์œผ๋กœ ๋„˜๊ฒจ์ค„ ์ปจํŠธ๋กค๋Ÿฌ ์ƒ์„ฑ ํ›„ RequestMapping ์—์„œ ๋งคํ•‘ํ•œ๋‹ค.

    • ์ด๋•Œ, ํ•ด๋‹น ์งˆ๋ฌธ์˜ ์ •๋ณด๋ฅผ GET๋ฐฉ์‹์œผ๋กœ URL์— ๋ช…์‹œํ•˜์—ฌ ์ „๋‹ฌํ•œ๋‹ค. (question.questionId)
  • ์ปจํŠธ๋กค๋Ÿฌ์—์„œ๋Š” ๊ธ€์“ด์ด์™€ ๋กœ๊ทธ์ธ ์‚ฌ์šฉ์ž๊ฐ€ ๋™์ผํ•œ์ง€ ๊ฒ€์‚ฌํ•œ๋‹ค.

    • ์ด๋•Œ, Question ์˜ isSameUser() ๋ฉ”์†Œ๋“œ๋ฅผ ๊ตฌํ˜„ํ•ด ์‚ฌ์šฉํ•˜๋„๋ก ํ•œ๋‹ค.
    • ํ•ด๋‹น ๋ฉ”์†Œ๋“œ์—๋Š” session์œผ๋กœ๋ถ€ํ„ฐ ์–ป์€ ๋กœ๊ทธ์ธ ์‚ฌ์šฉ์ž ์ •๋ณด๋ฅผ ์ธ์ž๋กœ ๋„˜๊ฒจ์ฃผ๊ณ , ์ด๋ฅผ ๋ฐ›์€ ๋ฉ”์†Œ๋“œ๋Š” writer id๋ฅผ ๊ฐ€์ง€๊ณ , ์‚ฌ์šฉ์ž๊ฐ€ ๋™์ผํ•œ์ง€ ๊ฒ€์‚ฌํ•œ๋‹ค.
  • ๋™์ผํ•œ ๊ฒฝ์šฐ์—๋งŒ ์งˆ๋ฌธ ์ˆ˜์ • ์ปจํŠธ๋กค๋Ÿฌ๋กœ ๋„˜๊ฒจ์ค€๋‹ค.
public class UpdateFormQuestionController extends AbstractController { private QuestionDao questionDao = new QuestionDao(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { if (!UserSessionUtils.isLogined(req.getSession())) { return jspView("redirect:/users/loginForm"); } Long questionId = Long.parseLong(req.getParameter("questionId")); Question question = questionDao.findById(questionId); if (!question.isSameUser(UserSessionUtils.getUserFromSession(req.getSession()))) { throw new IllegalStateException("๋ณธ์ธ์ด ์ž‘์„ฑํ•œ ๊ธ€๋งŒ ์ˆ˜์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค."); } return jspView("/qna/update.jsp").addObject("question", question); } }
  • /qna/update.jsp ๋Š” ์งˆ๋ฌธ์˜ ์ œ๋ชฉ๊ณผ ๋‚ด์šฉ์„ ์ˆ˜์ •ํ•  ์ˆ˜ ์žˆ๋Š” form ์ด ์žˆ๊ณ , /qna/update ๋กœ POST ์š”์ฒญ์„ ๋ณด๋‚ธ๋‹ค.
  • ์ด๋ฅผ ์ฒ˜๋ฆฌํ•  ์ปจํŠธ๋กค๋Ÿฌ ์ƒ์„ฑ ๋ฐ ๋งคํ•‘์„ ์ˆ˜ํ–‰ํ•œ๋‹ค.
  • ์ปจํŠธ๋กค๋Ÿฌ์—์„œ๋Š” questionId , title , contents ๋ฅผ ๋ฐ›์•„ ์งˆ๋ฌธ DB์— UPDATEํ•œ๋‹ค.

    • ๋จผ์ €, Question ์˜ update() ๋ฉ”์†Œ๋“œ๋กœ ๊ธฐ์กด ์งˆ๋ฌธ ๊ฐ์ฒด์˜ ์ •๋ณด๋ฅผ ๋ณ€๊ฒฝํ•˜๊ณ , QuestionDao ์˜ update() ๋ฉ”์†Œ๋“œ๋กœ QUESTION DB์— ์žˆ๋Š” ํ•ด๋‹น ์งˆ๋ฌธ์„ UPDATEํ•œ๋‹ค.
public class UpdateQuestionController extends AbstractController { private QuestionDao questionDao = new QuestionDao(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { if (!UserSessionUtils.isLogined(req.getSession())) { return jspView("redirect:/users/loginForm"); } long questionId = Long.parseLong(req.getParameter("questionId")); Question question = questionDao.findById(questionId); if (!question.isSameUser(UserSessionUtils.getUserFromSession(req.getSession()))) { throw new IllegalStateException("๋‹ค๋ฅธ ์‚ฌ์šฉ์ž๊ฐ€ ์“ด ๊ธ€์„ ์ˆ˜์ •ํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค."); } Question newQuestion = new Question(question.getWriter(), req.getParameter("title"), req.getParameter("contents")); question.update(newQuestion); questionDao.update(question); return jspView("redirect:/"); } }

"์„œ๋ฒ„์ธก์—์„œ ์•ˆ์ „ํ•œ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์ด ๋˜๋„๋ก ๋จผ์ € ๊ตฌํ˜„ํ•œ ํ›„ ํด๋ผ์ด์–ธํŠธ๋Š” ์ถ”ํ›„์— ๊ณ ๋ คํ•ด๋„ ๊ดœ์ฐฎ๋‹ค. ๊ทธ๋งŒํผ ์„œ๋ฒ„์ธก์—์„œ ๋ณด์•ˆ์— ๋Œ€ํ•œ ์ฒ˜๋ฆฌ๋ฅผ ์ค‘์š”ํ•˜๊ฒŒ ํ•ด์•ผ ํ•œ๋‹ค."

๐Ÿ’ก 12. ์ปจํŠธ๋กค๋Ÿฌ์—์„œ ์ ‘๊ทผํ•˜๋Š” QuestionDao ์™€ AnswerDao ์™€ ๊ฐ™์ด DAO์—์„œ DB ์ ‘๊ทผ ๋กœ์ง์„ ๊ตฌํ˜„ํ•  ๋•Œ ์‚ฌ์šฉํ•˜๋Š” JdbcTemplate ์€ ์ธ์Šคํ„ด์Šค๋ฅผ ์—ฌ๋Ÿฌ ๊ฐœ ์ƒ์„ฑํ•  ํ•„์š”์—†๋‹ค. ์ธ์Šคํ„ด์Šค๋ฅผ ํ•˜๋‚˜๋งŒ ์ƒ์„ฑํ•˜๋„๋ก ๊ตฌํ˜„ํ•œ๋‹ค.

  • ์œ„์—์„œ ์–ธ๊ธ‰ํ–ˆ๋“ฏ, Dao , Controller , JdbcTemplate ์€ ๋งค๋ฒˆ ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•˜์ง€ ์•Š์•„๋„ ๋œ๋‹ค. ์ƒํƒœ ๊ฐ’์„ ๊ฐ€์ง€์ง€ ์•Š์œผ๋ฉด์„œ ๋ฉ”์†Œ๋“œ๋งŒ ๊ฐ€์ง€๋Š” ํด๋ž˜์Šค์ด๊ธฐ ๋•Œ๋ฌธ์ด๋‹ค.
  • ๋”ฐ๋ผ์„œ ์ธ์Šคํ„ด์Šค ํ•˜๋‚˜๋งŒ ์ƒ์„ฑํ•ด ์žฌ์‚ฌ์šฉํ•˜๋„๋ก ํ•ด์•ผํ•˜๋Š”๋ฐ, ์ด๋Ÿฌํ•œ ๋””์ž์ธ ํŒจํ„ด์„ ์‹ฑ๊ธ€ํ†ค(Singleton) ํŒจํ„ด์ด๋ผ๊ณ  ํ•œ๋‹ค.

    • ๊ตฌํ˜„์„ ์œ„ํ•ด์„œ๋Š” ๋จผ์ € ํด๋ž˜์Šค์˜ ๊ธฐ๋ณธ ์ƒ์„ฑ์ž๋ฅผ private ์ ‘๊ทผ ์ œ์–ด์ž๋กœ ๊ตฌํ˜„ํ•˜์—ฌ ํด๋ž˜์Šค ์™ธ๋ถ€์—์„œ ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•  ์ˆ˜ ์—†๋„๋ก ํ•œ๋‹ค. (getInstance() ์™€ ๊ฐ™์€ static ๋ฉ”์†Œ๋“œ๋ฅผ ํ†ตํ•ด์„œ๋งŒ ์ƒ์„ฑ์ด ๊ฐ€๋Šฅํ•˜๋„๋ก ํ•œ๋‹ค.)
public class JdbcTemplate { private static JdbcTemplate jdbcTemplate; private JdbcTemplate() {} public static JdbcTemplate getInstance() { if (jdbcTemplate == null) { jdbcTemplate = new JdbcTemplate(); } return jdbcTemplate; } ... }
  • ์œ„์™€ ๊ฐ™์ด ์‹ฑ๊ธ€ํ†ค ํŒจํ„ด์„ ๊ตฌํ˜„ํ•˜๋Š” ๊ฒฝ์šฐ, ๋ฉ€ํ‹ฐ์Šค๋ ˆ๋“œ ํ™˜๊ฒฝ์—์„œ ๋™์‹œ์— getInstance() ๋ฉ”์†Œ๋“œ๋ฅผ ํ˜ธ์ถœํ•ด ์ธ์Šคํ„ด์Šค๊ฐ€ ํ•˜๋‚˜ ์ด์ƒ ์ƒ์„ฑ๋˜๋Š” ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๋‹ค.

    • ๋ฌธ์ œ๊ฐ€ ์žˆ์ง€๋งŒ, ๋’ค์—์„œ ๋‹ค๋ฃฐ ์˜์กด์„ฑ ์ฃผ์ž…(DI)์„ ์„ค๋ช…ํ•˜๊ธฐ ์œ„ํ•ด ์œ„์™€ ๊ฐ™์ด ๊ตฌํ˜„ํ–ˆ๋‹ค.

์‹ฑ๊ธ€ํ†ค ํŒจํ„ด์˜ ์žฅ๋‹จ์  ์žฅ์ 

  • ๊ณ ์ •๋œ ๋ฉ”๋ชจ๋ฆฌ ์˜์—ญ์„ ์–ป์œผ๋ฉด์„œ, ์ธ์Šคํ„ด์Šค๋ฅผ ํ•œ ๋ฒˆ๋งŒ ์ƒ์„ฑํ•˜๊ธฐ์— ๋ฉ”๋ชจ๋ฆฌ ๋‚ญ๋น„ ๋ฐฉ์ง€
  • ์ธ์Šคํ„ด์Šค๊ฐ€ ์ „์—ญ์œผ๋กœ ์ƒ์„ฑ๋˜์–ด, ๋‹ค๋ฅธ ํด๋ž˜์Šค์—์„œ์˜ ์ ‘๊ทผ ๋ฐ ๊ณต์œ ๊ฐ€ ์šฉ์ด
  • ์ด๋ฏธ ์ƒ์„ฑ๋˜์–ด ์žˆ๋Š” ์ธ์Šคํ„ด์Šค๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๊ฐ์ฒด ๋กœ๋”ฉ ์‹œ๊ฐ„์˜ ๊ฐ์†Œ

๋‹จ์ 

  • ์‹ฑ๊ธ€ํ†ค ์ธ์Šคํ„ด์Šค๊ฐ€ ๋„ˆ๋ฌด ๋งŽ์€ ์ž‘์—…์„ ์ฒ˜๋ฆฌํ•˜๊ฑฐ๋‚˜, ๋งŽ์€ ๋ฐ์ดํ„ฐ๋ฅผ ๊ณต์œ ํ•˜๋Š” ๊ฒฝ์šฐ ๋‹ค๋ฅธ ํด๋ž˜์Šค์˜ ์ธ์Šคํ„ฐ์Šค๋“ค ๊ฐ„์˜ ๊ฒฐํ•ฉ๋„๊ฐ€ ๋„ˆ๋ฌด ๋†’์•„์ ธ โ€œ๊ฐœ๋ฐฉ ํ์‡„ ์›์น™โ€์„ ์œ„๋ฐฐ
  • ์ด๋กœ ์ธํ•ด, ์ˆ˜์ • ๋ฐ ์œ ์ง€๋ณด์ˆ˜์˜ ๋น„์šฉ์ด ์ฆ๊ฐ€ํ•˜๊ณ , ๋ฉ€ํ‹ฐ์Šค๋ ˆ๋“œ ํ™˜๊ฒฝ์—์„œ ๋™๊ธฐํ™” ์ฒ˜๋ฆฌ๊ฐ€ ์—†๋‹ค๋ฉด ์ธ์Šคํ„ด์Šค๊ฐ€ ๋‘˜ ์ด์ƒ ์ƒ์„ฑ๋  ์ˆ˜ ์žˆ๋Š” ๊ฐ€๋Šฅ์„ฑ์ด ์กด์žฌ
JdbcTemplate jdbcTemplate = JdbcTemplate.getInstance();
  • JdbcTemplate ์„ ์‚ฌ์šฉํ•˜๋Š” Dao ์—์„œ ์œ„์™€ ๊ฐ™์ด JdbcTemplate.getInstance() ๋ฉ”์†Œ๋“œ๋กœ ์ธ์Šคํ„ด์Šค๋ฅผ ๋ฐ›์•„ ์‚ฌ์šฉํ•œ๋‹ค.

๐Ÿ’ก 13. ์งˆ๋ฌธ ์‚ญ์ œ ๊ธฐ๋Šฅ์„ ๊ตฌํ˜„ํ•œ๋‹ค. ์‚ญ์ œ๊ฐ€ ๊ฐ€๋Šฅํ•œ ๊ฒฝ์šฐ๋Š” ๋‹ต๋ณ€์ด ์—†๋Š” ๊ฒฝ์šฐ, ์งˆ๋ฌธ์ž์™€ ๋‹ต๋ณ€์ž๊ฐ€ ๋ชจ๋‘ ๊ฐ™์€ ๊ฒฝ์šฐ์ด๋‹ค. ์ด ๊ธฐ๋Šฅ์€ ์›น๊ณผ ๋ชจ๋ฐ”์ผ ์•ฑ์—์„œ ๋ชจ๋‘ ์ง€์›ํ•˜๋ ค๊ณ  ํ•œ๋‹ค. ์›น ๋ธŒ๋ผ์šฐ์ €๋ฅผ ํ†ตํ•ด ์ ‘๊ทผํ–ˆ์„ ๋•Œ๋Š” JspView ๋ฅผ ํ™œ์šฉํ•ด ๋ชฉ๋ก ํŽ˜์ด์ง€("redirect:/")๋กœ ์ด๋™ํ•˜๊ณ , ๋ชจ๋ฐ”์ผ ์•ฑ์„ ์ง€์›ํ•˜๊ธฐ ์œ„ํ•ด JsonView ๋ฅผ ํ™œ์šฉํ•ด ์‘๋‹ต ๊ฒฐ๊ณผ๋ฅผ JSON์œผ๋กœ ์ „์†กํ•˜๋ ค๊ณ  ํ•œ๋‹ค. ์ด๋ฅผ ์ง€์›ํ•˜๋ ค๋ฉด ๋‘ ๊ฐœ์˜ ์ปจํŠธ๋กค๋Ÿฌ๊ฐ€ ํ•„์š”ํ•˜๋‹ค. ๊ฐ ์ปจํŠธ๋กค๋Ÿฌ๋ฅผ ๊ตฌํ˜„ํ•˜๊ณ , ์ค‘๋ณต์„ ์ œ๊ฑฐํ•œ๋‹ค.

  • ๋จผ์ €, ์‚ญ์ œ ๋ฒ„ํŠผ ํด๋ฆญ ์‹œ ์š”์ฒญ์„ ๋ณด๋‚ผ URL์„ ๋ช…์‹œํ•˜๊ณ , ์ด๋ฅผ ์ฒ˜๋ฆฌํ•  ์ปจํŠธ๋กค๋Ÿฌ ์ƒ์„ฑ ๋ฐ ๋งคํ•‘์„ ์ˆ˜ํ–‰ํ•œ๋‹ค.

    • ๋˜ํ•œ, question.questionId ๋ฅผ ์š”์ฒญ๊ณผ ํ•จ๊ป˜ ์ „๋‹ฌํ•˜์—ฌ ์ด๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•œ๋‹ค.
public class DeleteQuestionController extends AbstractController { private QnaService qnaService = QnaService.getInstance(); @Override public ModelAndView execute(HttpServletRequest req, HttpServletResponse resp) throws Exception { if (!UserSessionUtils.isLogined(req.getSession())) { return jspView("redirect:/users/loginForm"); } long questionId = Long.parseLong(req.getParameter("questionId")); try { qnaService.deleteQuestion(questionId, UserSessionUtils.getUserFromSession(req.getSession())); return jspView("redirect:/"); } catch (CannotDeleteException e) { return jspView("show.jsp").addObject("question", qnaService.findById(questionId)) .addObject("answers", qnaService.findAllByQuestionId(questionId)) .addObject("errorMessage", e.getMessage()); } } } public class QnaService { private static QnaService qnaService; private QuestionDao questionDao = new QuestionDao(); private AnswerDao answerDao = new AnswerDao(); private QnaService() {} public static QnaService getInstance() { if (qnaService == null) { qnaService = new QnaService(); } return qnaService; } public Question findById(long questionId) { return questionDao.findById(questionId); } public List<Answer> findAllByQuestionId(long questionId) { return answerDao.findAllByQuestionId(questionId); } public void deleteQuestion(long questionId, User user) throws CannotDeleteException { Question question = questionDao.findById(questionId); if (question == null) { throw new CannotDeleteException("์กด์žฌํ•˜์ง€ ์•Š๋Š” ์งˆ๋ฌธ์ž…๋‹ˆ๋‹ค."); } if (!question.isSameUser(user)) { throw new CannotDeleteException("๋‹ค๋ฅธ ์‚ฌ์šฉ์ž๊ฐ€ ์“ด ๊ธ€์„ ์‚ญ์ œํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค."); } List<Answer> answers = answerDao.findAllByQuestionId(questionId); if (answers.isEmpty()) { questionDao.delete(questionId); return; } boolean canDelete = true; for (Answer answer : answers) { String writer = question.getWriter(); if (!writer.equals(answer.getWriter())) { canDelete = false; break; } } if (!canDelete) { throw new CannotDeleteException("๋‹ค๋ฅธ ์‚ฌ์šฉ์ž๊ฐ€ ์ถ”๊ฐ€ํ•œ ๋Œ“๊ธ€์ด ์กด์žฌํ•ด ์‚ญ์ œํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค."); } questionDao.delete(questionId); } }
  • QnaService ์„œ๋น„์Šค๋ฅผ ์ƒ์„ฑํ•˜์—ฌ ์งˆ๋ฌธ๊ณผ ๋‹ต๋ณ€์— ๋Œ€ํ•œ ์ฒ˜๋ฆฌ๋ฅผ ์ˆ˜ํ–‰ํ•œ๋‹ค.
  • ์—ฌ๊ธฐ์„œ๋Š”, deleteQuestion ์—์„œ

    • ์ธ์ž๋กœ ๋ฐ›์€ questionId ์— ํ•ด๋‹นํ•˜๋Š” ์งˆ๋ฌธ์„ ์ฐพ๊ณ ,
    • ํ•ด๋‹น ์งˆ๋ฌธ์˜ ์ž‘์„ฑ์ž์™€ ์ธ์ž๋กœ ๋ฐ›์€ user ๊ฐ€ ๋™์ผํ•œ์ง€ ๊ฒ€์‚ฌํ•œ ํ›„
    • ํ•ด๋‹น ์งˆ๋ฌธ์˜ ๋‹ต๋ณ€์ด ์žˆ๋Š”์ง€ ์—†๋Š”์ง€๋ฅผ ํŒ๋‹จํ•˜์—ฌ ์—†๋Š” ๊ฒฝ์šฐ์—๋งŒ ์งˆ๋ฌธ์„ ์‚ญ์ œํ•˜๊ณ  ๋ฐ˜ํ™˜๋œ๋‹ค.
    • ๊ทธ๋ ‡์ง€ ์•Š์€ ๊ฒฝ์šฐ, ์งˆ๋ฌธ์— ๋Œ€ํ•œ ๋‹ต๋ณ€ ์ž‘์„ฑ์ž๊ฐ€ ์‚ฌ์šฉ์ž ๋ณธ์ธ์ธ์ง€ ์•„๋‹Œ์ง€ ํŒ๋‹จํ•˜์—ฌ canDelete ๊ฐ’์ด false ๊ฐ€ ๋˜๋ฉด, ์ถ”๊ฐ€ํ•œ CannotDeleteException ์˜ˆ์™ธ๋ฅผ ๋˜์ง€๋„๋ก ํ•œ๋‹ค.
  • ์ถ”๊ฐ€์ ์œผ๋กœ, ๋ชจ๋ฐ”์ผ ์ง€์›์„ ์œ„ํ•ด ApiDeleteQuestionController ๋ฅผ ์ƒ์„ฑํ•˜๊ณ , ๋งคํ•‘ํ•œ๋‹ค.

    • ์ด๋Š” jspView() ๊ฐ€ ์•„๋‹Œ jsonView() ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๋„๋ก ํ•œ๋‹ค.

๐Ÿ’ก 14. 13๋ฒˆ ๋ฌธ์ œ๋ฅผ ๊ตฌํ˜„ํ•  ๋•Œ ๋‹จ์œ„ ํ…Œ์ŠคํŠธ๊ฐ€ ๊ฐ€๋Šฅํ•˜๋„๋ก ํ•œ๋‹ค. Dao๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๋ชจ๋“  ์ปจํŠธ๋กค๋Ÿฌ ํด๋ž˜์Šค๋Š” DB๊ฐ€ ์„ค์น˜๋˜์–ด ์žˆ์–ด์•ผ ํ•˜๋ฉฐ, ํ…Œ์ด๋ธ”๊นŒ์ง€ ์ƒ์„ฑ๋˜์–ด ์žˆ๋Š” ์ƒํƒœ์—์„œ๋งŒ ํ…Œ์ŠคํŠธ๊ฐ€ ๊ฐ€๋Šฅํ•˜๋‹ค. DB๊ฐ€ ์กด์žฌํ•˜์ง€ ์•Š๋Š” ์ƒํƒœ์—์„œ๋„ ์œ„ ๋กœ์ง์„ ๋‹จ์œ„ ํ…Œ์ŠคํŠธํ•˜๋ ค๊ณ  ํ•œ๋‹ค.

  • 13๋ฒˆ ๋ฌธ์ œ๋Š” ์งˆ๋ฌธ ์‚ญ์ œ ๊ธฐ๋Šฅ์„ ์›น๊ณผ ๋ชจ๋ฐ”์ผ ๋ชจ๋‘์— ์ œ๊ณตํ•˜๊ธฐ ์œ„ํ•ด 2๊ฐœ์˜ Controller ๊ตฌํ˜„ ์‹œ ๋ฐœ์ƒํ•˜๋Š” ์ค‘๋ณต์„ ์–ด๋–ป๊ฒŒ ์ œ๊ฑฐํ•  ๊ฒƒ์ธ๊ฐ€์— ๋Œ€ํ•œ ๋ฌธ์ œ์ด๋‹ค.

    • ์ด ์š”๊ตฌ์‚ฌํ•ญ์„ ๋งŒ์กฑํ•˜๋„๋ก DeleteQuestionController , ApiDeleteQuestionController ํด๋ž˜์Šค๋ฅผ ๊ตฌํ˜„ํ–ˆ๋‹ค.
    • ์›๋ž˜ ๊ตฌํ˜„๋Œ€๋กœ๋ผ๋ฉด, questionId ๋ฅผ ๊ฐ€์ ธ์™€ ์งˆ๋ฌธ์„ ๋จผ์ € ์กฐํšŒํ•˜๊ณ , ์ž‘์„ฑ์ž์™€ ์ˆ˜์ •ํ•˜๋ ค๋Š” ์‚ฌ์šฉ์ž๊ฐ€ ๋™์ผํ•œ์ง€ ๊ฒ€์‚ฌํ•˜๊ณ , ํ•ด๋‹น ์งˆ๋ฌธ์— ๋Œ€ํ•œ ๋‹ต๋ณ€์„ ์กฐํšŒํ•œ ๋’ค, ๋‹ต๋ณ€์˜ ์ž‘์„ฑ์ž๊นŒ์ง€ ๋‹ค ํ™•์ธํ•ด์•ผํ•˜๋Š” ๊ณผ์ • ๋ชจ๋‘ ๋™์ผํ•˜๊ณ , ์‘๋‹ตํ•  ๋ทฐ(JspView , JsonView)๋งŒ ๋‹ค๋ฅด๋‹ค.
    • ์ด์— ๋Œ€ํ•œ ์ค‘๋ณต์„ ์ œ๊ฑฐํ•ด์•ผ ํ•œ๋‹ค.

๋ฐฉ๋ฒ•์€ 2๊ฐ€์ง€๊ฐ€ ์žˆ๋‹ค.

  • ์ด ๋‘ ํด๋ž˜์Šค์— ๋Œ€ํ•œ ๋ถ€๋ชจ ํด๋ž˜์Šค๋ฅผ ์ถ”๊ฐ€ํ•ด ์ค‘๋ณต ๋กœ์ง์„ ๋ถ€๋ชจ ํด๋ž˜์Šค๋กœ ์ด๋™ํ•œ ํ›„ ์ƒ์†์„ ํ†ตํ•ด ์ค‘๋ณต์„ ์ œ๊ฑฐํ•œ๋‹ค.
  • ์ปจํŠธ๋กค๋Ÿฌ๊ฐ€ DAO์™€ ์˜์กด๊ด€๊ณ„๋ฅผ ํ†ตํ•ด DB ์ ‘๊ทผ ๋กœ์ง์„ ์ œ๊ฑฐํ–ˆ๋“ฏ ์ƒˆ๋กœ์šด ํด๋ž˜์Šค๋ฅผ ์ถ”๊ฐ€ํ•ด ๋กœ์ง ์ฒ˜๋ฆฌ๋ฅผ ์œ„์ž„ํ•˜์—ฌ ์ค‘๋ณต์„ ์ œ๊ฑฐํ•œ๋‹ค. โ†’ "์กฐํ•ฉ"(composition)

    • ์ƒ์†์˜ ๊ฒฝ์šฐ ๋ถ€๋ชจ ํด๋ž˜์Šค์— ๋ณ€๊ฒฝ์ด ๋ฐœ์ƒํ•˜๋ฉด ์ž์‹ ํด๋ž˜์Šค์—๋„ ์˜ํ–ฅ์ด ์ƒ๊ธฐ๊ธฐ ๋•Œ๋ฌธ์— ์ƒ์†๋ณด๋‹ค๋Š” ์กฐํ•ฉ์„ ํ†ตํ•ด ์ค‘๋ณต์„ ์ œ๊ฑฐํ•  ๊ฒƒ์„ ์ถ”์ฒœํ•œ๋‹ค.

์ž๋ฐ” ์ง„์˜์—์„œ๋Š” ์ด๋Ÿฌํ•œ ์ค‘๋ณต ์ œ๊ฑฐ์™€ ์ปจํŠธ๋กค๋Ÿฌ ์—ญํ•  ๋ถ„๋ฆฌ ๋“ฑ์˜ ๋ชฉ์ ์œผ๋กœ Service(๋˜๋Š” Manager)๋ผ๋Š” ํด๋ž˜์Šค๋ฅผ ์ถ”๊ฐ€ํ•ด ๋‹ด๋‹นํ•˜๋„๋ก ๊ตฌํ˜„ํ•œ๋‹ค. ๋”ฐ๋ผ์„œ ์œ„ ๋ฌธ์ œ์—์„œ๋Š” QnaService ๋ผ๋Š” ํด๋ž˜์Šค๋ฅผ ์ถ”๊ฐ€ํ•œ๋‹ค.

public class QnaService { private static QnaService qnaService; private QuestionDao questionDao = new QuestionDao(); private AnswerDao answerDao = new AnswerDao(); private QnaService() {} public static QnaService getInstance() { if (qnaService == null) { qnaService = new QnaService(); } return qnaService; } public Question findById(long questionId) { return questionDao.findById(questionId); } public List<Answer> findAllByQuestionId(long questionId) { return answerDao.findAllByQuestionId(questionId); } public void deleteQuestion(long questionId, User user) throws CannotDeleteException { Question question = questionDao.findById(questionId); if (question == null) { throw new CannotDeleteException("์กด์žฌํ•˜์ง€ ์•Š๋Š” ์งˆ๋ฌธ์ž…๋‹ˆ๋‹ค."); } if (!question.isSameUser(user)) { throw new CannotDeleteException("๋‹ค๋ฅธ ์‚ฌ์šฉ์ž๊ฐ€ ์“ด ๊ธ€์„ ์‚ญ์ œํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค."); } List<Answer> answers = answerDao.findAllByQuestionId(questionId); if (answers.isEmpty()) { questionDao.delete(questionId); return; } boolean canDelete = true; for (Answer answer : answers) { String writer = question.getWriter(); if (!writer.equals(answer.getWriter())) { canDelete = false; break; } } if (!canDelete) { throw new CannotDeleteException("๋‹ค๋ฅธ ์‚ฌ์šฉ์ž๊ฐ€ ์ถ”๊ฐ€ํ•œ ๋Œ“๊ธ€์ด ์กด์žฌํ•ด ์‚ญ์ œํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค."); } questionDao.delete(questionId); } }
  • ์ด ํด๋ž˜์Šค ๋˜ํ•œ ์ƒํƒœ ๊ฐ’์„ ๊ฐ€์ง€์ง€ ์•Š์•„ ์‹ฑ๊ธ€ํ†ค ํŒจํ„ด์œผ๋กœ ๊ตฌํ˜„ํ•œ๋‹ค.
  • deleteQuestion() ๊ฐ€ DeleteQuestionController ์™€ ApiDeleteQuestionController ํด๋ž˜์Šค์—์„œ์˜ ์ค‘๋ณต ์ฝ”๋“œ๋ฅผ ๊ตฌํ˜„ํ•œ ๋กœ์ง์ด๋‹ค.

    • ์ด๋ ‡๊ฒŒ ์ปจํŠธ๋กค๋Ÿฌ์—์„œ์˜ ๋ณต์žกํ•˜๊ณ  ์ค‘๋ณต๋œ ๋กœ์ง์„ ์„œ๋น„์Šค๋กœ ์œ„์ž„ํ–ˆ๊ธฐ์—, ์ปจํŠธ๋กค๋Ÿฌ์—์„œ๋Š” ์ •์ƒ์ ์œผ๋กœ ์‚ญ์ œ๊ฐ€ ๋˜๋Š” ๊ฒฝ์šฐ์™€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ๊ฒฝ์šฐ์— ๋”ฐ๋ฅธ ์ฒ˜๋ฆฌ๋งŒ ๊ตฌํ˜„ํ•  ์ˆ˜ ์žˆ๊ฒŒ ๋œ๋‹ค.
    • ์ด๋•Œ, CannotDeleteException ์ด๋ผ๋Š” ์ปดํŒŒ์ผํƒ€์ž„ Exception์„ throw ํ•œ๋‹ค.
    • ์ด์™€ ๊ฐ™์ด ์‚ฌ์šฉ์ž์—๊ฒŒ ์˜ˆ์™ธ์ฒ˜๋ฆฌ๋ฅผ ํ†ตํ•ด ์—๋Ÿฌ ๋ฉ”์„ธ์ง€๋ฅผ ์ „๋‹ฌํ•˜๊ฑฐ๋‚˜, ๋‹ค๋ฅธ ์ž‘์—…์„ ํ•˜๋„๋ก ์œ ๋„ํ•  ํ•„์š”๊ฐ€ ์žˆ๋Š” ๊ฒฝ์šฐ ๋Ÿฐํƒ€์ž„ Exception๋ณด๋‹ค ์ปดํŒŒ์ผํƒ€์ž„ Exception์ด ์ ํ•ฉํ•˜๋‹ค.

๊ณ„์ธตํ˜• ์•„ํ‚คํ…์ฒ˜ : ์ปจํŠธ๋กค๋Ÿฌ, ์„œ๋น„์Šค, DAO ๊ตฌ์กฐ๋กœ ์›น ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ๊ฐœ๋ฐœํ•˜๋Š” ๊ฒƒ

์งˆ๋ฌธ ์‚ญ์ œ๋ฅผ ๋‹ด๋‹นํ•˜๋Š” ํด๋ž˜์Šค๋“ค์„ ๊ณ„์ธตํ˜• ์•„ํ‚คํ…์ฒ˜๋กœ ๋‚˜ํƒ€๋‚ด๋ฉด ์˜ค๋ฅธ์ชฝ๊ณผ ๊ฐ™๋‹ค. ์ตœ๊ทผ์—๋Š” DB ์ ‘๊ทผ ๋กœ์ง์„ ๋‹ด๋‹นํ•˜๋Š” ํด๋ž˜์Šค ์ด๋ฆ„์„ DAO ๋Œ€์‹  Repository๋กœ ๊ตฌํ˜„ํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์•„์ง€๊ณ  ์žˆ๋‹ค. Domain ๊ฐ์ฒด์— ํ•ด๋‹นํ•˜๋Š” ํด๋ž˜์Šค๋Š” Question & Answer ์ด๋‹ค.

๐Ÿ’ก 15. RequestMapping ์ฝ”๋“œ๋ฅผ ๋ณด๋ฉด, ์ปจํŠธ๋กค๋Ÿฌ ์ถ”๊ฐ€๋งˆ๋‹ค ์š”์ฒญ URL๊ณผ ์ปจํŠธ๋กค๋Ÿฌ๋ฅผ ์ถ”๊ฐ€ํ•ด์•ผ ํ•˜๋Š” ๋ถˆํŽธํ•จ์ด ์žˆ๋‹ค. ์„œ๋ธ”๋ฆฟ๊ณผ ๊ฐ™์ด annotation์„ ํ™œ์šฉํ•ด ์„ค์ •์„ ์ถ”๊ฐ€ํ•˜๊ณ  ์„œ๋ฒ„๊ฐ€ ์‹œ์ž‘ํ•  ๋•Œ ์ž๋™์œผ๋กœ ๋งคํ•‘์ด ๋˜๋„๋ก ๊ฐœ์„ ํ•œ๋‹ค.

  • @Controller ์„ค์ •์„ ํ†ตํ•œ ์ƒˆ๋กœ์šด MVC๋Š” ๋‹ค์Œ ์žฅ์—์„œ ๊ตฌํ˜„ํ•œ๋‹ค.

๐Ÿ“• ์ถœ์ฒ˜

@Seongukbaek
๋ฐฐ์šฐ๊ณ  ์ •๋ฆฌํ•˜๊ณ  ๊ณต์œ ํ•˜๋Š” ๋Œ€ํ•™์ƒ ๋ฐฑ์„ฑ์šฑ์ž…๋‹ˆ๋‹ค ๐Ÿ˜€